create  table jms_dm.dm_reback_timely_rate_sum 
(
date_time timestamp COMMENT '' ,
actual_network_code varchar(100) COMMENT '' ,
actual_network_name varchar(100) COMMENT '' ,
total_num      bigint COMMENT '总件量' ,
total_money    varchar(100) COMMENT '总件量' ,
total_is_timely_true  varchar(100) COMMENT '总及时件量' ,
total_is_timely_false  varchar(100) COMMENT '总不及时量' ,
is_timely_true      varchar(100) COMMENT '类型分类,及时' ,
is_timely_false     varchar(100) COMMENT '类型分类,不及时' ,
waybill_num               bigint COMMENT '件量' ,
waybill_money     varchar(100) COMMENT '罚款金额' ,
duty_cal_1   varchar(100) COMMENT '1未打印面单' ,
duty_cal_2   varchar(100) COMMENT '2已打印未发出' ,
duty_cal_3   varchar(100) COMMENT '3已打印漏扫发件' ,
duty_cal_4   varchar(100) COMMENT '4非应操作网点发出' ,
duty_cal_5   varchar(100) COMMENT '5下一站晚到' ,
duty_cal_6   varchar(100) COMMENT '6虚假发件' ,
type_flg varchar(100) COMMENT '' )
ENGINE=OLAP
DUPLICATE KEY(填写key)
comment 'insert overwrite table jms_dm.dm_reback_timely_rate_sum partition(dt)'
PARTITION BY RANGE (date_time) ( 
   START ("2023-06-21") END ("2023-08-20") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(site_code) BUCKETS 4
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "4",
"in_memory" = "false",
"storage_format" = "V2"
);